|
Showing 1 - 4 of
4 matches in All Departments
A comprehensive guide to building, managing, and securing scalable
and reliable database and data warehousing applications using
Postgres 12 and 13 Key Features Set up your database cluster and
monitor, secure, and fine-tune it for optimal performance Learn the
fundamentals of database management and implement client- and
server-side programming using SQL and PL/pgSQL Explore useful tips
to develop efficient PostgreSQL database solutions from scratch
Book DescriptionPostgreSQL is one of the fastest-growing open
source object-relational database management systems (DBMS) in the
world. As well as being easy to use, it's scalable and highly
efficient. In this book, you'll explore PostgreSQL 12 and 13 and
learn how to build database solutions using it. Complete with
hands-on tutorials, this guide will teach you how to achieve the
right database design required for a reliable environment. You'll
learn how to install and configure a PostgreSQL server and even
manage users and connections. The book then progresses to key
concepts of relational databases, before taking you through the
Data Definition Language (DDL) and commonly used DDL commands. To
build on your skills, you'll understand how to interact with the
live cluster, create database objects, and use tools to connect to
the live cluster. You'll then get to grips with creating tables,
building indexes, and designing your database schema. Later, you'll
explore the Data Manipulation Language (DML) and server-side
programming capabilities of PostgreSQL using PL/pgSQL, before
learning how to monitor, test, and troubleshoot your database
application to ensure high-performance and reliability. By the end
of this book, you'll be well-versed with the Postgres database and
be able to set up your own PostgreSQL instance and use it to build
robust solutions. What you will learn Understand how users and
connections are managed by running a PostgreSQL instance Interact
with transaction boundaries using server-side programming Identify
bottlenecks to maintain your database efficiently Create and manage
extensions to add new functionalities to your cluster Choose the
best index type for each situation Use online tools to set up a
memory configuration that will suit most databases Explore how
Postgres can be used in multi-instance environments to provide
high-availability, redundancy, and scalability Who this book is
forThis Postgres book is for anyone interested in learning about
the PostgreSQL database from scratch. Anyone looking to build
robust data warehousing applications and scale the database for
high-availability and performance using the latest features of
PostgreSQL will also find this book useful. Although prior
knowledge of PostgreSQL is not required, familiarity with databases
is expected.
Extend PostgreSQL using PostgreSQL server programming to create,
test, debug, and optimize a range of user-defined functions in your
favorite programming language Key Features Learn the concepts of
PostgreSQL 11 with lots of real-world datasets and examples Learn
queries, data replication, and database performance Extend the
functionalities of your PostgreSQL instance to suit your
organizational needs Book DescriptionPostgreSQL is a rock-solid,
scalable, and safe enterprise-level relational database. With a
broad range of features and stability, it is ever increasing in
popularity.This book shows you how to take advantage of PostgreSQL
11 features for server-side programming. Server-side programming
enables strong data encapsulation and coherence. The book begins
with the importance of server-side programming and explains the
risks of leaving all the checks outside the database. To build your
capabilities further, you will learn how to write stored
procedures, both functions and the new PostgreSQL 11 procedures,
and create triggers to perform encapsulation and maintain data
consistency. You will also learn how to produce extensions, the
easiest way to package your programs for easy and solid deployment
on different PostgreSQL installations. What you will learn Explore
data encapsulation Write stored procedures in different languages
Interact with transactions from within a function Get to grips with
triggers and rules Create and manage custom data types Create
extensions to package code and data Implement background workers
and Inter-Process Communication (IPC) How to deal with foreign
languages, in particular Java and Perl Who this book is forThis
book is for database administrators, data engineers, and database
engineers who want to implement advanced functionalities and master
complex administrative tasks with PostgreSQL 11.
|
|